<?php
try{
    $db = new PDO("mysql:host=localhost;dbname=db2;", 'root', '12qwas');
    $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
    $ps=$db->prepare('delete from students where xh=?');
    $ps->execute([$_GET['xh']]);
    if($ps->rowCount()===0)throw  new Exception(message: '没有成功删除记录');
    header(header: 'Location: index.php');
    return;
} catch (Throwable $e){
    $msg=$e->getMessage();
}
?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport"
          content="width=device-width, user-scalable=no, initial-scale=1.0, maximum-scale=1.0, minimum-scale=1.0">
    <meta http-equiv="X-UA-Compatible" content="ie=edge">
    <title>删除新用户</title>
    <style>
        h1{color: red}

        .msg{color: red;margin: 20px 0;}
    </style>
</head>
<body>
<h1>删除新用户</h1>
<div class="msg">
    <?=$msg?>
</div>
</body>
</html>



